Adding, editing, and duplicating tasks

As the default tasks are generated automatically, there is usually no reason to manually create or duplicate a task. An exception to this is if you import your model from ERwin without first defining global mappings. In such a case, you will need to manually add the task and create the mappings.

For more information on global mappings, see Managing global mappings.

One possible reason to duplicate a task is if your model contains different types of tables and you want to manage them in separate ETLs.

Adding tasks

To add a new task:

1. Click the Manage button at the bottom left of the Data Warehouse panel. The Manage Data Warehouse Tasks window opens.

2. Click the New Task toolbar button. The New Task dialog opens.

3. Specify a name for the task.

   Warning noteTask names cannot contain the following characters: /\,&#%$@=^*+"'`~?<>:;[]{} as well as all non-printable characters (below 0x20). The task name can contain a single dot, but it cannot be the first or last character.

4. Optionally, provide a description.

5. Select one of the following task types according to your needs:

   • Full Load: Loads the selected tables into the data warehouse.

   • Change Processing: Updates the data warehouse tables with the source table changes.

   Warning noteDo not select a task type that conflicts with you Replicate task. For instance, do not select Change Processing if your Replicate task is Full Load only.
6. Click OK to create the task. Select the task name in the left pane and continue from Editing column mappings.

Editing tasks

To edit an existing task:

1. Click the Manage button at the bottom left of the Data Warehouse panel. The Manage Data Warehouse Tasks window opens.

2. In the left pane, double-click the task you want to edit or hover your mouse cursor over the task and click the button.

3. Edit the task as described in steps 3-5 of Adding tasks above and then click OK.

4. Generate the task as described in Generating data warehouse tasks.

Duplicating tasks

To duplicate an existing task:

1. Click the Manage button at the bottom left of the Data Warehouse panel. The Manage Data Warehouse Tasks window opens.

2. Select the task you want to duplicate and then click the Duplicate toolbar button. The Duplicate window opens.

3. Specify a Name for the new task.
4. Select a Landing Zone.
5. Optionally change the default Schema.

6. Select one of the available task types.

   Warning noteDo not select a task type that conflicts with you Replicate task. For instance, do not select Change Tables Only if your Replicate task is Full Load only.
7. Click OK.
8. Select the task name in the left pane and continue from Editing column mappings.